CursorA cursor is a data buffer opened by the system for the user, which holds the results of the SQL statement execution. Each cursor area has a name that allows the user to retrieve the record from the cursor one at a-and assign it to the main
1. What is a cursor?① Retrieve the result set from the table and point to a record for interaction at a time.② Operations in relational databases are performed on the complete set of rows.The row set returned by the SELECT statement includes all
1, what is a cursor? ① retrieves the result set from the table, and the mechanism from which each point points to a record for interaction.The operations in the ② relational database are performed on the complete rowset.The rowset returned by the
A MS-SQL cursor is a temporary database object that is used to rotate copies of data rows stored in a system Permanent Table, it can also point to the data row stored in the system Permanent Table. A cursor provides you with a method to operate data
1, what is a cursor.① retrieves a result set from a table from which the mechanism for interacting with each record is pointed.Operations in the ② relational database are performed on a complete rowset.The rowset returned by the SELECT statement
During database development, when the data you retrieve is only one record, the transaction statement code you write usually uses the Select Insert statement. However, we often encounter this situation, that is, reading a record from a result set
During database development, when the data you retrieve is only one record, the transaction statements you writeCodeSelect Insert statements are usually used. However, we often encounter this situation, that is, reading a record from a result set
During database development, when the data you retrieve is only one record, the transaction statements you writeCodeSelect Insert statements are usually used. However, we often encounter this situation, that is, reading a record from a result set
1. What is a cursor?① Retrieve the result set from the table and point to a record for interaction at a time.② Operations in relational databases are performed on the complete set of rows.The row set returned by the SELECT statement includes all
Original url:http://www.2cto.com/database/201203/122387.htmlOracle Cursor Concepts Explained
What is a cursor? ① retrieves the result set from the table, and the mechanism from which each point points to a record for interaction. The
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.